SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = object_id('dbo.lib_list_book'))
	DROP PROCEDURE dbo.lib_list_book
GO

CREATE PROCEDURE dbo.lib_list_book

AS
BEGIN
	SET NOCOUNT ON;
	
	SELECT * FROM book ORDER BY book_no;
END
GO